var user = {
    queryAll: 'select * from y_active where subject like ? LIMIT ? , 5 ',
    insert: 'INSERT INTO y_active(subject, startTime,number,status,activeDetailId,location) VALUES(?,?,?,1,?,?)',
    queryById: 'select subject,startTime,number,status,activeDetailId,location,id from y_active where id = ?',
    queryByName: "select * from y_active where subject like ?",
    insertInvite: "update y_active set number = number+1 where id=?",
    updateActive: 'update y_active set subject=?, startTime=?, number=?, location=?  where id=?',
    del: 'delete from y_active where activeDetailId = ?',
    queryComingActive: 'SELECT * FROM y_active WHERE status="1" ',
    queryNews:'SELECT subject,startTime,location FROM y_active',
};

module.exports = user;
/**
 * Created by Administrator on 2015/8/6.
 */
